package com.ocom.company.dao;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ocom.common.entity.master.EntityCompanyList;
import com.ocom.common.vo.company.ComStatusCountVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface IDaoCompanyListInfo extends BaseMapper<EntityCompanyList> {

	@Select("select  com_status ,  count(com_id) as nowComNum   " +
			"from company_list " +
			"where is_agent = 0  and  com_id between  #{beginComId} and #{endComId}  " +
			"group by com_status ")
	public List<ComStatusCountVo> selectComStatusCount(@Param("beginComId") Long beginComId,@Param("endComId")  Long endComId);


}
